BA - With Example
Business Analytics (BA) Business Analytics is the practice of using data, statistical methods, and quantitative techniques to understand patterns, make predictions, and support better business decisions. It goes beyond just reporting—it uses statistics, modeling, and data mining to find insights that help organizations improve performance.
Example of Business Analytics
A Retail Store Analyzing Sales Data A retail company wants to understand:- Why some products sell more than others
- How pricing affects sales
- What factors influence monthly revenue
- Whether discounts increase sales significantly
| Month | Sales (units) | Price | Discount (%) | Advertising Spend |
|---|---|---|---|---|
| 1 | 400 | 800 | 15 | 2000 |
| 2 | 450 | 500 | 10 | 0 |
| 3 | 500 | 670 | 10 | 5000 |
| 4 | 700 | 680 | 10 | 8000 |
| 5 | 600 | 890 | 18 | 6000 |
| 6 | 480 | 900 | 20 | 7000 |
| 7 | 590 | 340 | 9 | 6000 |
| 8 | 770 | 450 | 10 | 1000 |
| 9 | 580 | 560 | 12 | 1300 |
| 10 | 300 | 590 | 14 | 0 |
| 11 | 340 | 780 | 17 | 2100 |
| 12 | 410 | 890 | 16 | 1200 |
Statistical Analysis Used
A. Correlation Analysis To see relationships:- Price vs Sales: -0.357
- Negative correlation (as price increases, sales drop)
- Discount vs Sales: -0.459
- Negative correlation (as Discounts increase sales drop)
- Ad Spend vs Sales: 0.427
- Positive correlation: More advertising increases sales
sales = 698.91 - 0.12 * Price - 14.12 * Discount + 0.02 * AdSpend
The store builds a multiple linear regression: Interpretation:- For every 1 unit increase in price, sales drop by 0.12 units
- For every 1% increase in discount, sales decrease by 14.12 units
- Every Rs.100 increase in advertising adds 0.02 units of sales
Insights (BA Output)
- Insight 1: Price is the strongest factor
Raising price drastically reduces sales. So managers should avoid frequent price hikes.
- Insight 2: Discounts significantly boost sales
But high discounts reduce profit margin—so they should be used strategically.
- Insight 3: Advertising has positive but moderate impact
Meaning moderate ad spend works, but overspending doesn't add much extra sales.
Business Decision (Prescriptive Outcome)
Using the statistical model, the company decides:- Keep product price between NPR 95 - 100
- Offer 5 - 10% discount during monthends
- Maintain ad spending at NPR 2500 monthly
- As a result, they expect a 12 - 18% increase in monthly sales.